microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 36

When a row of data is to be converted into columns

a) Copy the cells in row, select the same number of cells in row and paste

b) Copy the cells in column then choose Edit > > Paste Special, then click Transpose and OK

c) Copy the cells then go to Format > > Cells then on Alignment tab click Transpose check box and click OK

d) Select the cells then place the cell pointer on new cell and choose Edit » Paste Special, mark Transpose check box and click OK.

e) None of these

Question : 37

To edit data in an embedded Excel worksheet object in a Word document

a) Use the Excel menu bar and toolbars inside the word application

b) Edit the hyperlink

c) Edit the data in a Excel source application

d) Use the Word menu bar and toolbars

Question : 38

You can print only an embedded chart by

a) Moving the chart to a chart sheet before you print.

b) Formatting the chart before you print

c) Selecting the chart before you print

d) a and c

e) None of these

Question : 39

In Excel to copy cell contents using drag and drop, press the

a) End key

b) Shift key

c) Esc key

d) None of above

Question : 40

An excel workbook is a collection of

a) Workbooks

b) Worksheets

c) Charts

d) Worksheets and charts

e) None of these